import pandas as pd

def get_excel_case_data(interface_type):
    data = pd.read_excel('./case_data/测试用例.xlsx')
    interface_type_data = data[data['请求接口类别']==interface_type]
    final_data = []
    # print(interface_type_data)
    start_index = 0
    for i in interface_type_data.index:
        inner_data = {}
        # print("--------"+str(i))
        # for d in interface_type_data.iloc[[i]]:
        for d in interface_type_data.iloc[[start_index]]:
            # print("*****"+str(d))
            inner_data[d] = interface_type_data[d][i]
        final_data.append(inner_data)
        start_index += 1
    # return interface_type_data
    return final_data


